package com.example.menuvirtualclient.dbschema;

public class TCompany {

	public static String CreateTable(){
		StringBuilder sb = new StringBuilder();
		sb.append("CREATE TABLE Companies (");
		sb.append("id INTEGER PRIMARY KEY AUTOINCREMENT,");
		sb.append("name TEXT,");
		sb.append("address TEXT,");
		sb.append("codeIdentity TEXT,");
		sb.append("phone TEXT);");
		
		return sb.toString();
	}
	
	public static String InsertRow() {
		StringBuilder sb = new StringBuilder();
		sb.append("INSERT INTO Companies (name, address, codeIdentity, phone)");
		sb.append("VALUES ('El Positano', 'Av. Ejercito del Norte 2058', '20-20556321-7', '4223695');");
		
		return sb.toString();
	}
	
}
